Microsoft Office 2016 Step by Step by Joan Lambert & Curtis Frye

Author:Joan Lambert & Curtis Frye [Lambert, Joan]
Language: eng
Format: azw3
Publisher: Pearson Education
Published: 2015-11-19T05:00:00+00:00

* * *

Important

If you save and close a workbook while a scenario is in effect, those values become the default values for the cells changed by the scenario! You should seriously consider creating a scenario that contains the original values of the cells you change or creating a scenario summary worksheet (a subject covered in the next topic).

* * *

The tools available in the Scenario Manager also let you edit your scenarios and delete the ones you no longer need.

To define an alternative data set by creating a scenario

1. On the Data tab, in the Forecast group, click the What-If Analysis button to display a menu of the what-if choices, and then click Scenario Manager.

2. In the Scenario Manager dialog box, click Add.

3. In the Scenario name box, enter a name for the scenario.

4. Click in the Changing cells box, and then select the cells you want to change.

5. Click OK.

6. In the Scenario Values dialog box, enter new values for each of the changing cells.

7. Click OK.

8. Click Close to close the Scenario Manager dialog box.

To display an alternative data set

1. On the What-if Analysis menu, click Scenario Manager.

2. In the Scenario Manager dialog box, click the scenario you want to display.

3. Click Show.

4. If you want to close the Scenario Manager dialog box, click Close.

To edit an alternative data set

1. On the What-If Analysis menu, click Scenario Manager.

2. In the Scenario Manager dialog box, click the scenario you want to edit.

3. Click Edit.

4. In the Edit Scenario dialog box, change the values in the Scenario name, Changing cells, or Comment box.

5. Click OK.

6. In the Scenario Values dialog box, enter new values for each of the changing cells.

7. Click OK.

8. Click Close to close the Scenario Manager dialog box.

To delete an alternative data set

1. On the What-if Analysis menu, click Scenario Manager.

2. In the Scenario Manager dialog box, click the scenario you want to delete.

3. Click Delete.

4. Click Close to close the Scenario Manager dialog box.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.